USE [ExpH]
GO
/****** Object:  Table [dbo].[Invoice_GRN]    Script Date: 06/20/2023 12:45:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_GRN](
	[Inv_GRNID] [bigint] IDENTITY(1,1) NOT NULL,
	[Inv_GRNDate] [datetime] NOT NULL,
	[Inv_GRNVNo] [varchar](16) NOT NULL,
	[SessionID] [smallint] NOT NULL,
	[Remarks] [varchar](150) NULL,
	[ReadOnly] [bit] NOT NULL CONSTRAINT [DF_Invoice_GRN_ReadOnly]  DEFAULT ((0)),
	[LoginID] [int] NOT NULL,
	[HostName] [varchar](50) NULL CONSTRAINT [DF_Invoice_GRN_HostName]  DEFAULT (host_name()),
	[EntryDateTime] [datetime] NULL CONSTRAINT [DF_Invoice_GRN_EntryDateTime]  DEFAULT (getdate()),
	[ModifyID] [int] NULL,
	[ModifyHostName] [varchar](50) NULL,
	[ModifyDateTime] [datetime] NULL,
	[BEDate] [datetime] NULL,
	[SupplierID] [int] NULL,
	[ShipID] [smallint] NULL,
	[ShipLineID] [smallint] NULL,
	[ContainerTypeID] [smallint] NULL,
	[BENo] [varchar](50) NULL,
	[VoyNo] [varchar](50) NULL,
	[Currency] [varchar](50) NOT NULL,
	[ContainerNo] [varchar](200) NULL,
	[NoOfContainers] [decimal](11, 2) NOT NULL CONSTRAINT [DF_Invoice_GRN_NoOfContainers]  DEFAULT ((0)),
	[SumQTY] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_GRN_SumQTY]  DEFAULT ((0)),
	[SumNetWT] [decimal](15, 4) NOT NULL,
	[SumGrossWT] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_GRN_SumGrossWT]  DEFAULT ((0)),
	[SumGWTotal] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_GRN_SumGWTotal]  DEFAULT ((0)),
	[SumNetTotal] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_GRN_SumNetTotal]  DEFAULT ((0)),
	[SumAmount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_GRN_SumAmount]  DEFAULT ((0)),
	[NetInvoice] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_GRN_NetInvoice]  DEFAULT ((0)),
 CONSTRAINT [PK_Invoice_GRN] PRIMARY KEY CLUSTERED 
(
	[Inv_GRNID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Invoice_GRNItem]    Script Date: 06/20/2023 12:45:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_GRNItem](
	[inv_GRNItemID] [bigint] IDENTITY(1,1) NOT NULL,
	[inv_GRNID] [bigint] NOT NULL,
	[ItemID] [smallint] NULL,
	[VarietyID] [smallint] NULL,
	[LQTY] [numeric](15, 4) NOT NULL,
	[Type] [tinyint] NOT NULL,
	[ContainerNo] [varchar](20) NULL,
 CONSTRAINT [PK_Invoice_GRNItem] PRIMARY KEY CLUSTERED 
(
	[inv_GRNItemID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Invoice_GRNPacking]    Script Date: 06/20/2023 12:45:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_GRNPacking](
	[inv_GRNPackID] [bigint] IDENTITY(1,1) NOT NULL,
	[inv_GRNID] [bigint] NOT NULL,
	[ShipMarkID] [smallint] NULL,
	[PackageID] [smallint] NULL,
	[ItemID] [smallint] NULL,
	[Qty] [numeric](15, 4) NOT NULL,
	[NetWT] [decimal](15, 4) NOT NULL,
	[GrossWT] [decimal](15, 4) NOT NULL,
	[GWTotal] [decimal](15, 4) NOT NULL,
	[NetTotal] [numeric](15, 4) NOT NULL,
	[Rate] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_GRNPacking_Rate]  DEFAULT ((0)),
	[Amount] [numeric](15, 4) NOT NULL,
	[Type] [tinyint] NOT NULL,
	[ItemRemarks] [varchar](30) NULL,
	[RateRemarks] [varchar](30) NULL,
	[RateType] [varchar](30) NULL,
	[PRemarks] [varchar](50) NULL,
	[PAmount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_GRNPacking_PAmount]  DEFAULT ((0)),
 CONSTRAINT [PK_Invoice_GRNPacking] PRIMARY KEY CLUSTERED 
(
	[inv_GRNPackID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF